<?php			
/**
 * @version		$Id: params.php 2011.08.11 thierry $
 * @package		admin.nodels
 * @subpackage	com_projid
 * @copyright	Copyright (C) 2011 Pojid All rights reserved.
 * @license		GNU General Public License version 2 or later; see LICENSE.txt
 */
defined('_JEXEC') or die('Restricted access');
jimport('joomla.application.component.modellist');

class ProjidModelParams extends JModelList
{
	/**
	 * Method to build an SQL query to load the list data.
	 *
	 * @return	string	An SQL query
	 */
	protected function getListQuery() 
	{
		// Create a new query object.
		$db = JFactory::getDBO();
		$query = $db->getQuery(true);

		// Select some fields
		$query->select('id_param,param_name,param_desc, param_type,desc_que, param_default');

		// From the hello table
		$query->from('#__projid_birt_parameter');

		$query->leftjoin('#__projid_requete on #__projid_birt_parameter.requete_id=#__projid_requete.id_que');
		return $query;
	}
}